<?php
	session_start();

	include("mysql_connect.php");
		
	$strSqlCommand = "SELECT City
						FROM ResidentialProperty tbRP
						LEFT JOIN Listing  tbLT			ON tbRP.Listing_idListing = tbLT.idListing
						LEFT JOIN StreetAddress  tbSA	ON tbLT.StreetAddress_idStreetAddress = tbSA.idStreetAddress
						WHERE City LIKE '%'
						GROUP BY City";
		
	//echo $strSqlCommand;
		
	$result = mysql_query($strSqlCommand);
	
	echo '<option selected="selected">Any</option>';
	//echo $strSqlCommand;
	while($rowAddress = @mysql_fetch_array($result))	
	{// URL, Price,idListing
		echo '<option>'.$rowAddress['City'].'</option>';
	}
	
?>